Best Of
Why does newly created grid/sheet come with pre-populated columns & 1 row?
I've recently created a new sheet / grids and it has come with pre-populated columns and 1 row of data. How can I have a new sheet / grid be blank? I'm losing time by having to undo these prepopulated columns.
Carol C
Get LIVE stock prices from the Stock Exchange
One of my prospective customers currently uses excel (built-in STOCK data type & function) to pull in live Securities Price Data from the stock market (NSE). They are considering Smartsheet for Report updates and distribution, and asked if Smartsheet can directly pull in the LIVE STOCK data (as excel does). Would be nice to have this feature - will extend the usability of Smartsheet in the Finance domain as well.
shashanksinha
Allow choosing editable vs. read-only columns in manual update requests.
System
Re: Issue with transcribing a reference formula for Add-On Rates
With this formula you are collecting ALL the add-ons for a given company that match that name ("Expedited") and then choosing the first one. For these customers, I presume you have expedited proofread AND expedited hourly review available - and if you choose the first one there is no certainty that you'll choose the one you intend.
Add, to your collect() formula, a criteria for your "Service Requested" and you'll probably be good.
Jgorsich
Re: How come I can't delete a scheduled report?
I'm sorry! I should have mentioned that. It's a scheduled email report I created from a report I created from a sheet I created. It's weird. How can I delete it? I've created, scheduled and deleted emailed reports off of the same report. But for some reason this one won't delete.
Tracey D.
Re: Duplicate Checkbox Column
Try this:
=IF(Created@row <> MAX(COLLECT(Created:Created, [Row ID]:[Row ID], @cell = [Row ID]@row)), 1)
Paul Newcome
Auto login to Resource Management from Dashboards and WorkApp
While Smartsheet did recently release a method for accessing Resource Management from the left navigation, our team finds more value in looking at the "Reports" I've set up within RM. Reports that I've embedded within our Smartsheet WorkApp, as well as within Smartsheet Dashboards. Issue is, when trying to review the reports you are asked to sign into RM which then takes you to a new browser tab, where you then need to go back to the WorkApp and refresh your session. It's very frustrating for our team and they've been inquiring for some time if there's an easier way for them to view these reports. I don't want them going into the RM tool as many have the Portfolio Editor access and they can actually "delete" my reports - which is NOT good. Also, the user interface in RM to see the list of reports is truncated and hard to read. I'd rather them be able to access from Smartsheet - if not for forcing them to have to separately log in each time. Can there be an enhancement request for this? Can this process be streamlined and added to the Resource Management roadmap?
Thank you.
Erica L.
Re: 2 sheets for daily production and production schedule for a PO (month) =Status
Thank you! I was actually able to do a helper column after I did a sumifs for the total amount of cases for my quantity >= 100% on my production schedule. If we produce more than the PO amount it will place a check mark in my helper column. I then set up automation to change the status to Assembly Complete.
rruchty
Re: Deactivate form after set # of entries/submissions OR by date
Add the ability to set an end date for form submission. We use forms to survey our department. Would be nice to set an end date rather than having to go in and 'inactivate' it.
Susan Hornberger
Re: Dashboards on TV without computer
Has anyone had luck using a BrightSign player to show live dashboards? I have been trying to use a series 5 brightsign to show our dashboard, however the screen just gives a connectivity error from SmartSheets (See attached).
I'm using the Publishing Link generated from the dashboard. The link is sharable to anyone who receives it, so no account needed. I tested that from another computer using Chrome and my phone.
It's worth noting that brightsign uses Chromium to display webpages, so it should react similar to Chrome when rendering the HTML file. It's also worth mentioning that I'm able to reach any other website including SmartSheet.com via the same methods as the Dashboard link. The only issue I have otherwise, is not being able to log in with my Smartsheet Credentials when using the BrightSign. Again, I think it's a chromium issue, but want to be sure. Any thoughts!?
strefnoff